Problem Note 49994: The error "No terminal connected to the SAS® session" occurs when you open a DBMS table from SAS® Enterprise Guide®
When you define a database library in SAS® Management Console, you choose one of three possible values for the Authentication Type field for the database server connection for that library. The three choices for the Authentication Type field are as follows:
- (none) specifies that credentials are not used to connect to the server.
- User/Password specifies that credentials are retrieved from metadata corresponding to the selected authentication domain.
- Prompt specifies that the user is prompted for credentials when connecting to the server.
If you set the Authentication Type to Prompt to create a database server for the database library in SAS Management Console, you might not be able to open a table from SAS Enterprise Guide from this library. The following error might occur:
If you want SAS Enterprise Guide to prompt you for a database user ID and password, follow the steps in SAS Note 46674: "How to have SAS® Enterprise Guide® prompt you for a database user ID and password."
Operating System and Release Information
| SAS System | SAS Enterprise Guide | Microsoft® Windows® for x64 | 4.3 | 6.1 | 9.2 TS2M3 | 9.4 TS1M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.3 | | 9.2 TS2M3 | |
| Microsoft Windows Server 2003 Enterprise Edition | 4.3 | | 9.2 TS2M3 | |
| Microsoft Windows Server 2003 Standard Edition | 4.3 | | 9.2 TS2M3 | |
| Microsoft Windows Server 2003 for x64 | 4.3 | | 9.2 TS2M3 | |
| Microsoft Windows Server 2008 | 4.3 | 6.1 | 9.2 TS2M3 | 9.4 TS1M3 |
| Microsoft Windows Server 2008 for x64 | 4.3 | 6.1 | 9.2 TS2M3 | 9.4 TS1M3 |
| Microsoft Windows XP Professional | 4.3 | | 9.2 TS2M3 | |
| Windows 7 Enterprise 32 bit | 4.3 | 6.1 | 9.2 TS2M3 | 9.4 TS1M3 |
| Windows 7 Enterprise x64 | 4.3 | 6.1 | 9.2 TS2M3 | 9.4 TS1M3 |
| Windows 7 Home Premium 32 bit | 4.3 | 6.1 | 9.2 TS2M3 | 9.4 TS1M3 |
| Windows 7 Home Premium x64 | 4.3 | 6.1 | 9.2 TS2M3 | 9.4 TS1M3 |
| Windows 7 Professional 32 bit | 4.3 | 6.1 | 9.2 TS2M3 | 9.4 TS1M3 |
| Windows 7 Professional x64 | 4.3 | 6.1 | 9.2 TS2M3 | 9.4 TS1M3 |
| Windows 7 Ultimate 32 bit | 4.3 | 6.1 | 9.2 TS2M3 | 9.4 TS1M3 |
| Windows 7 Ultimate x64 | 4.3 | 6.1 | 9.2 TS2M3 | 9.4 TS1M3 |
| Windows Vista | 4.3 | | 9.2 TS2M3 | |
| Windows Vista for x64 | 4.3 | | 9.2 TS2M3 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Attempting to open a database table from SAS Enterprise Guide might result in the following error: "Open data operation failed [ERROR] No terminal connected to the SAS session when opening a DBMS table from SAS Enterprise Guide"
| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> data management
|
| Date Modified: | 2015-11-09 13:16:48 |
| Date Created: | 2013-05-20 15:57:37 |
